package com.appkubes.mall.restful.application.goods.taobao.dao;

import com.appkubes.mall.core.dao.BaseMallGoodsTaobaoDao;
import com.appkubes.mall.core.entity.MallGoodsTaobao;
import com.appkubes.mall.restful.application.goods.taobao.model.GoodsTaobaoModel;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Description: 淘宝商品
 * @Author: jeecg-boot
 * @Date: 2020-01-12
 * @Version: V1.0
 */
@Mapper
@Repository
public interface GoodsTaobaoDao extends BaseMallGoodsTaobaoDao {
    @Select(
            "select goods_key,goods_id,main_pic,dtitle,coupon_total_num,coupon_receive_num,actual_price,commission_rate,two_hours_sales,shop_type," +
                    "coupon_price,month_sales,shop_name,marketing_main_pic,coupon_link,item_link,promotion_text" +
                    " from mall_goods_taobao order by rand()"
    )
    IPage<MallGoodsTaobao> getBoutique(Page<GoodsTaobaoModel> pageInfo);
}
